use school;
select * from student
insert into student values (3,'ABC','LKG',7);
select * from student
insert into student values (4,'ABC',1,7);
insert into student values ('5','EFG','1stClass',8);
insert into student values ('six','EFG','1stClass',8)
insert into student values (6,'EFG','2stClass')

insert into student values ('ABC',3,'LKG',7);

insert into student(int,char,char,int) 
	values (3,'ABC','LKG',7) -- Success
	values ('ABC',3,'LKG',7) -- Error (First value datatype)
	values (6,'EFG','2stClass') -- Error (Column count)
	values ('six','EFG','1stClass',8) --Error (First value datatype)
	values ('5','EFG','1stClass',8); --Success


--Inserting multiple rows data with single insert statement
	insert into student (RollNUm,Name,Grade,Age) 
		values	(6,'XYZ','LKG',5), 
				(7,'YZX','UKG',6), 
				(8,'PQR','2stClass',8), 
				(9,'RST','Nursary',4), 
				(10,'TUV','1stClass',6);